<?php

if (!defined('BASEPATH'))
    exit('No direct script access allowed');
/**
 * CodeIgniter
 *
 * An open source application development framework for PHP 5.1.6 or newer
 *
 * @package        CodeIgniter
 * @author        Esen Sagynov
 * @copyright    Copyright (c) 2008 - 2011, EllisLab, Inc.
 * @license        http://codeigniter.com/user_guide/license.html
 * @link        http://codeigniter.com
 * @since        Version 1.0
 * @filesource
 */
// ------------------------------------------------------------------------

/**
 * CUBRID Forge Class
 *
 * @category    Database
 * @author        Esen Sagynov
 * @link        http://codeigniter.com/user_guide/database/
 */
class CI_DB_cubrid_forge extends CI_DB_forge {

    /**
     * Create database
     *
     * @access    private
     * @param    string    the database name
     * @return    bool
     */
    function _create_database($name) {
        // CUBRID does not allow to create a database in SQL. The GUI tools
        // have to be used for this purpose.
        return FALSE;
    }

    // --------------------------------------------------------------------

    /**
     * Drop database
     *
     * @access    private
     * @param    string    the database name
     * @return    bool
     */
    function _drop_database($name) {
        // CUBRID does not allow to drop a database in SQL. The GUI tools
        // have to be used for this purpose.
        return FALSE;
    }

    // --------------------------------------------------------------------

    /**
     * Process Fields
     *
     * @access    private
     * @param    mixed    the fields
     * @return    string
     */
    function _process_fields($fields) {
        $current_field_count = 0;
        $sql = '';

        foreach ($fields as $field => $attributes) {
            // Numeric field names aren't allowed in databases, so if the key is
            // numeric, we know it was assigned by PHP and the developer manually
            // entered the field information, so we'll simply add it to the list
            if (is_numeric($field)) {
                $sql .= "\n\t$attributes";
            } else {
                $attributes = array_change_key_case($attributes, CASE_UPPER);

                $sql .= "\n\t\"" . $this->db->_protect_identifiers($field) . "\"";

                if (array_key_exists('NAME', $attributes)) {
                    $sql .= ' ' . $this->db->_protect_identifiers($attributes['NAME']) . ' ';
                }

                if (array_key_exists('TYPE', $attributes)) {
                    $sql .= ' ' . $attributes['TYPE'];

                    if (array_key_exists('CONSTRAINT', $attributes)) {
                        switch ($attributes['TYPE']) {
                            case 'decimal':
                            case 'float':
                            case 'numeric':
                                $sql .= '(' . implode(',', $attributes['CONSTRAINT']) . ')';
                                break;
                            case 'enum':     // As of version 8.4.0 CUBRID does not support
                                // enum data type.
                                break;
                            case 'set':
                                $sql .= '("' . implode('","', $attributes['CONSTRAINT']) . '")';
                                break;
                            default:
                                $sql .= '(' . $attributes['CONSTRAINT'] . ')';
                        }
                    }
                }

                if (array_key_exists('UNSIGNED', $attributes) && $attributes['UNSIGNED'] === TRUE) {
                    //$sql .= ' UNSIGNED';
                    // As of version 8.4.0 CUBRID does not support UNSIGNED INTEGER data type.
                    // Will be supported in the next release as a part of MySQL Compatibility.
                }

                if (array_key_exists('DEFAULT', $attributes)) {
                    $sql .= ' DEFAULT \'' . $attributes['DEFAULT'] . '\'';
                }

                if (array_key_exists('NULL', $attributes) && $attributes['NULL'] === TRUE) {
                    $sql .= ' NULL';
                } else {
                    $sql .= ' NOT NULL';
                }

                if (array_key_exists('AUTO_INCREMENT', $attributes) && $attributes['AUTO_INCREMENT'] === TRUE) {
                    $sql .= ' AUTO_INCREMENT';
                }

                if (array_key_exists('UNIQUE', $attributes) && $attributes['UNIQUE'] === TRUE) {
                    $sql .= ' UNIQUE';
                }
            }

            // don't add a comma on the end of the last field
            if (++$current_field_count < count($fields)) {
                $sql .= ',';
            }
        }

        return $sql;
    }

    // --------------------------------------------------------------------

    /**
     * Create Table
     *
     * @access    private
     * @param    string    the table name
     * @param    mixed    the fields
     * @param    mixed    primary key(s)
     * @param    mixed    key(s)
     * @param    boolean    should 'IF NOT EXISTS' be added to the SQL
     * @return    bool
     */
    function _create_table($table, $fields, $primary_keys, $keys, $if_not_exists) {
        $sql = 'CREATE TABLE ';

        if ($if_not_exists === TRUE) {
            //$sql .= 'IF NOT EXISTS ';
            // As of version 8.4.0 CUBRID does not support this SQL syntax.
        }

        $sql .= $this->db->_escape_identifiers($table) . " (";

        $sql .= $this->_process_fields($fields);

        // If there is a PK defined
        if (count($primary_keys) > 0) {
            $key_name = "pk_" . $table . "_" .
                $this->db->_protect_identifiers(implode('_', $primary_keys));

            $primary_keys = $this->db->_protect_identifiers($primary_keys);
            $sql .= ",\n\tCONSTRAINT " . $key_name . " PRIMARY KEY(" . implode(', ', $primary_keys) . ")";
        }

        if (is_array($keys) && count($keys) > 0) {
            foreach ($keys as $key) {
                if (is_array($key)) {
                    $key_name = $this->db->_protect_identifiers(implode('_', $key));
                    $key = $this->db->_protect_identifiers($key);
                } else {
                    $key_name = $this->db->_protect_identifiers($key);
                    $key = array($key_name);
                }

                $sql .= ",\n\tKEY \"{$key_name}\" (" . implode(', ', $key) . ")";
            }
        }

        $sql .= "\n);";

        return $sql;
    }

    // --------------------------------------------------------------------

    /**
     * Drop Table
     *
     * @access    private
     * @return    string
     */
    function _drop_table($table) {
        return "DROP TABLE IF EXISTS " . $this->db->_escape_identifiers($table);
    }

    // --------------------------------------------------------------------

    /**
     * Alter table query
     *
     * Generates a platform-specific query so that a table can be altered
     * Called by add_column(), drop_column(), and column_alter(),
     *
     * @access    private
     * @param    string    the ALTER type (ADD, DROP, CHANGE)
     * @param    string    the column name
     * @param    array    fields
     * @param    string    the field after which we should add the new field
     * @return    object
     */
    function _alter_table($alter_type, $table, $fields, $after_field = '') {
        $sql = 'ALTER TABLE ' . $this->db->_protect_identifiers($table) . " $alter_type ";

        // DROP has everything it needs now.
        if ($alter_type == 'DROP') {
            return $sql . $this->db->_protect_identifiers($fields);
        }

        $sql .= $this->_process_fields($fields);

        if ($after_field != '') {
            $sql .= ' AFTER ' . $this->db->_protect_identifiers($after_field);
        }

        return $sql;
    }

    // --------------------------------------------------------------------

    /**
     * Rename a table
     *
     * Generates a platform-specific query so that a table can be renamed
     *
     * @access    private
     * @param    string    the old table name
     * @param    string    the new table name
     * @return    string
     */
    function _rename_table($table_name, $new_table_name) {
        $sql = 'RENAME TABLE ' . $this->db->_protect_identifiers($table_name) . " AS " . $this->db->_protect_identifiers($new_table_name);
        return $sql;
    }

}

/* End of file cubrid_forge.php */
/* Location: ./system/database/drivers/cubrid/cubrid_forge.php */